ashutosh.kumarpandey (2/3/2012)

---

I know but a) cross join does not require any common key between the two table b) it will increase the number of column in the output which I...

Sean Lange (2/3/2012)

---

Are you trying to build an update sproc that will only update the columns that are supplied? That seems like an awful lot of extra overhead and processing....

Laura_SqlNovice (2/3/2012)

---

Hi Guys,

I have an SP which has table column names as input parameters. The proc uses dynamic query and uses column names from input parameter to update the columns......

Make sure you read Jeff Moden's running total article, what I'm about to show you is not even nearly as good.

BEGIN TRAN

IF object_id('tempdb..#testEnvironment') IS NOT NULL

BEGIN

DROP TABLE #testEnvironment

END

--100 Random rows...

You could get rid of that cursor as well, if you use something like this: -

DECLARE @sql AS NVARCHAR(MAX)

SELECT @sql = COALESCE(@SQL,'') + ';' + CHAR(13) + CHAR(10) +

'SELECT a.name,...

Jamie Ashton (2/3/2012)

---

Hello,

I have a situation where I am trying to do a bulk insert of a file that's on a network share. It's failing with:

Cannot bulk load because the...

DECLARE @sql NVARCHAR(2000), @Where NVARCHAR(1000), @mande BIGINT

SET @mande=0

SET @sql = 'UPDATE balance' +CHAR(13)+CHAR(10)+

'SET @mande = bal = @innerMande + (bad - bas),' +CHAR(13)+CHAR(10)+

'tash = (CASE WHEN bal > 0' +CHAR(13)+CHAR(10)+

...

raotor (2/3/2012)

---

Hello,

I am using SQL Server 2008R2 SP1 and have a problem when it comes to getting SSMS to script certain tables.

If I right-click on a table within SSMS and...

I made a...

In fairness, there's not much difference in execution times.

BEGIN TRAN

SET NOCOUNT ON

--1,000,000 Random rows of data

SELECT TOP 1000000 ABS(CHECKSUM(NEWID())) AS...

"diLip" (2/2/2012)

---

CREATE TABLE Table1 (ID1 int, ID2 int,ID3 int)

insert into Table1(ID1,ID2,ID3)

select 1,2,3

union all

select 4,5,6

union all

select 7,8,9

How can I display just the number 9 as the highest value from all...

It was introduced for SQL Server 2008, so I guess the question should read "On SQL Server 2008 and above, what is...

BEGIN TRAN

CREATE TABLE t1 (marks INT)

CREATE TABLE t2 (comments VARCHAR(10))

INSERT INTO t1

VALUES (100)

INSERT INTO t1

VALUES (200)

INSERT INTO t2

VALUES ('d')

INSERT INTO t2

VALUES ('i')

--The results here can't be guaranteed because SQL Server...

Oh dear. . . has it been a long day?...

Paul Morris-1011726 (2/1/2012)

---

groovy...

I apologize I am still a bit of a NOOB with this... I was trying to read up on what you provided to understand what it is doing......