Search results

View table definition in TSQL TSQL

OK will add some notes in this thread Something similar with Oracle

In Azure SQL I was wondering if anyone had tried to save the Create table/view generated SQL scripts in some way automatically to a linked ms access table from specified remotely linked SQL Azure database. I only need specified tables and views.. (I am talking about SSMS which has an option to...

Thanked count is the one thing I miss I wonder might be worth making a suggestion to the developers of the forum software?

One thing I would say you might want to investigate which I don't think has been discussed is time period. Typically in sales/production environments you want to know the popular sold & produced units in the last year / month or week in relation to all other time periods. The most popular of...

I'm just thinking about this kind of thing now. I'm thinking of a structure where you have one table for everyone and relatives (at least genetically) are referred to each other by their parentage. To try and prevent loop through input of wrong data. A parent mother or father must at least have...

Hang on I see there is an actual relevant thread in the Modules and VBA posted yesterday of all times... I'll have a look at that.

Dear All I have a single table of a list of persons that is referenced to itself for the father and mother field. So lets say its called t001 and has a primary key of PKID structure is similar to the following where pkidt001mother and pkidt002father is referenced to itself. pkid firstname...

I think I just enjoy the act of investigation more than 'work' sometimes.. I know I can get easily distracted when I have been on a project for a while and I suddenly remember some interesting thing that I wanted to take a look at..... 5 hours later...

On a bit of a tangent please be aware that I think Access at least 2003 (I suspect it is the same for all other versions) could only handle about 13 nested iifs in a single SQL statement before it errors. I was once involved in a ETL project and had to replace a lot of values in a table I ended...

Just went to Utter Access its consistently reading in the 2.5 second mark however looks like it is asnychronous loading as first paint looks like it comes in around the 0.5-1 second mark and then it takes a while to load in adverts etc... leading to the final time in the mid 2-3 second mark...

Excellent question - this new site is pretty fast for me.. I actually have a chrome plug in which I use to measure all web applications that I build and it just measures every page time I go to. Load Time Plugin Chrome And for me on the desktop (I can't measure on my mobile) I'm getting load...

OK not sure how that works but will try it out.

Congratulations Jon so far I think the only thing I miss is the thanks record. Mobile experience is vastly better.

Here's another reference about finding maximum or grouping child records which is similar to the link to Allen Browne's site but maybe not as indepth Select Distinct list of Child Records based on a Maximum or Minimum Child Field Value

I think Xenforo does appear to be an improvement. Would like to see the stats more easily of posters but once you know where to look its probably ok... I've come across width concerns with responsive designs as well. Sometimes its easily configurable and sometimes its not. Width however is...

I'm probably not going to implement this computed field but I managed to work out the syntax so for reference. TSQL - SQL Azure ALTER TABLE ProjectManagement ADD FutureorPast AS CAST ( CASE WHEN TargetDate > GetDate() or TargetDate is Null THEN 'FUTURE' WHEN TargetDate <= GetDate() THEN 'PAST'...

Doesn't annoy me but I do notice it. I wouldn't choose it if it could be removed.

I can see why you are nervous Jon - I m not a massive fan of mobile for this kind of thing as I very rarely access it that way. Also there is quite a bit of loss of detail on the stats of the individual users on the left hand side. Might be configurable - don't know but you don't get an instant...

Thanks Maj - didn't really make my question clear. Its an SQL Azure database linked to an ASP.NET application. The amount of data is insignificant - we are talking about 5000 records growing at about 100 records a month. I am just getting to grips with functions in SQL and find computed...