vipin_jha123 (4/10/2015)

---

Hi,

I am getting error in my below sql statement

Declare @sqlquery varchar(max)

Set @sqlquery='INSERT INTO dbo.Staging_Temp_1 fnGetFirstOcurrences(col001, '¯',@Columns),LoadDate FROM dbo.Staging_Temp'

Select @sqlquery

error:-

Msg 102, Level 15, State 1, Line 11

Incorrect syntax...

Try this

😎

SELECT

OBJECT_NAME(ASM.object_id) AS OBJ_NAME

,OBJECT_SCHEMA_NAME(ASM.object_id) AS OBJ_SCHEMA_NAME

,CASE WHEN ASM.definition LIKE N'%UPDATE%' ...

Slightly different approach, only scans each table once

😎

USE tempdb;

GO

SET NOCOUNT ON;

declare @vehicle table(id int, vehiclemake varchar(10), vehiclemodel varchar(10));

declare @vehicleclass table(id int, vehiclemake varchar(10), vehiclemodel varchar(10), classtype varchar(1));

insert into @vehicle values

...

Thanks Steve!

😎

BTW, the leading "#" is included in the count, BOL does not mention that.

Jeff Moden (4/9/2015)

---

Eirikur Eiriksson (4/9/2015)

---

tcronin 95651 (4/9/2015)

---

I have baselines, just stunned to see this happen, I have been a dba for 20 years and 99% of the time this happens...

Sigerson (4/9/2015)

---

ZZartin (4/3/2015)

---

In my last job I managed...

Sean Lange (4/9/2015)

---

My workplace participates in the “Take Your Daughters and Sons to Work Day” and I have to give a 10-15 minute presentation about how important technology is to...

MMM (Many Mountains Moving)

Sean Lange (4/9/2015)

---

Thanks!!! Not sure why I pointed out a possible concern and stopped short of providing an alternative. Been a heck of a week around the office...thankfully the weekend...

Good point, then we use the sys.all_sql_modules

😎

SELECT

...

tcronin 95651 (4/9/2015)

---

I have baselines, just stunned to see this happen, I have been a dba for 20 years and 99% of the time this happens either blocking or someone...

Seen almost the same before, the difference being the text qualifiers and the missing parameter delimiter. Guess you will have to query the...

tcronin 95651 (4/9/2015)

---

no blocking that was the first thing I looked for. I had dropped an unused index the night before on a table that the stored proc that...

He he, not the thing I would think of in the context of...

Grant Fritchey (4/9/2015)

---

tcronin 95651 (4/9/2015)

---

May have found the needle, started going through the snapshots Idera DM saves, as I scrolled through I noticed there is one stored procedure with about...