Ian Scarlett (10/30/2015)

---

Really? I understand the grief nulls can cause, but without them how do you...

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...

Brandie Tarvin (10/30/2015)

---

Anyone here with mad C# skills? I need some help with a VS 2012 C# project that I'm updating.

Nevermind. One of our developers finally responded to my request...

Now I know how the people on the other side of "the pond" feel when the humor questions are US centered. 😀

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...

I don't see the problem with your code. Probably if you give more details on the problem.

CREATE TABLE #Temp(

LastName varchar(10),

...

RPSql (10/29/2015)

---

;WITH QUERY1 ( Total_Physical_Memory_In_MB,NumberofCPU )

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

...

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...

Have you tried this?

http://www.sqlservercentral.com/articles/CROSS+APPLY+VALUES+UNPIVOT/91234/

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...

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...

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

Irene

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...

A different way to do it.

SELECT rowid,

YEAR( dateMeeting),

MONTH( dateMeeting),

DAY( dateMeeting),

STUFF( (hoursMeeting * 100) +...