Viewing 15 posts - 3,931 through 3,945 (of 8,731 total)
Meatloaf (10/30/2015)
Is there a way to make all data appear in one column so I would have a row like this:A,B,C,D,E,F,G, A_InMin,A_InMax,B_InMin,B_InMax,C_InMin,C_InMax,D_InMin,D_InMax,E_InMin,E_InMax,F_InMin,F_InMax,G_InMin,G_InMax,
Do you mean one column or one row?
For one...
October 30, 2015 at 8:37 am
Ian Scarlett (10/30/2015)
I believe that most theorists would prefer blank spaces instead of null values.
Really? I understand the grief nulls can cause, but without them how do you...
October 30, 2015 at 7:28 am
Hi Kristen,
Just wondering. Why did you go with that path and not the opposite by making all the columns not nullable? I believe that most theorists would prefer blank spaces...
October 30, 2015 at 6:41 am
Brandie Tarvin (10/30/2015)
Nevermind. One of our developers finally responded to my request...
October 30, 2015 at 6:32 am
Now I know how the people on the other side of "the pond" feel when the humor questions are US centered. 😀
October 30, 2015 at 6:28 am
Just a wild guess. You might have selected part of the update without the where clause and ran the query. That would have prevented the code to work as expected...
October 29, 2015 at 2:35 pm
I don't see the problem with your code. Probably if you give more details on the problem.
CREATE TABLE #Temp(
LastName varchar(10),
...
October 29, 2015 at 2:10 pm
RPSql (10/29/2015)
AS (SELECT [total_physical_memory_kb] / 1024 AS [Total_Physical_Memory_In_MB],
CPU_Count AS NumberofCPU
FROM [master].[sys].[dm_os_sys_memory]
CROSS JOIN sys.dm_os_sys_info
...
October 29, 2015 at 1:45 pm
This is your first post here, so you might not be used to it. In SQL forums, it's a good practice to post your sample data in a way that...
October 29, 2015 at 1:40 pm
Have you tried this?
http://www.sqlservercentral.com/articles/CROSS+APPLY+VALUES+UNPIVOT/91234/
October 29, 2015 at 1:28 pm
Strings can be compared and the ones that come first in alphabetical order are lower than the ones that come last.
Example:
CREATE TABLE #Sample(
myString varchar(1));
INSERT INTO...
October 29, 2015 at 1:14 pm
This is one of those examples where people think that a while loop is a better option than a cursor, but it very possibly isn't.
The while loop gets the first...
October 29, 2015 at 1:09 pm
Very simple:
SELECT [total_physical_memory_kb] / 1024 AS [Total_Physical_Memory_In_MB],
CPU_Count AS NumberofCPU
FROM [master].[sys].[dm_os_sys_memory]
CROSS JOIN sys.dm_os_sys_info
October 29, 2015 at 11:46 am
DonlSimpson (10/29/2015)
anthony.green (10/29/2015)
Ed Wagner (10/29/2015)
anthony.green (10/29/2015)
crookj (10/29/2015)
TossSalad
Greens
Me
Myself
Irene
October 29, 2015 at 11:27 am
I'm curious. Why would you need to drop and recreate the Foreign Key constraints?
If it's for renaming purposes, I would simply rename them.
If it's for rebuilding the indexes, I would...
October 29, 2015 at 10:23 am
Viewing 15 posts - 3,931 through 3,945 (of 8,731 total)