Viewing 15 posts - 5,266 through 5,280 (of 26,490 total)
SQLRNNR (5/8/2015)
Lynn Pettis (5/8/2015)
Jeff Moden (5/8/2015)
Lynn Pettis (5/8/2015)
Jeff Moden (5/8/2015)
SQLRNNR (5/8/2015)
Lynn Pettis (5/8/2015)
Geez, now someone doesn't even understand that the code they are running generates and runs dynamic SQL.
What is...
May 8, 2015 at 4:42 pm
Jeff Moden (5/8/2015)
Lynn Pettis (5/8/2015)
Jeff Moden (5/8/2015)
SQLRNNR (5/8/2015)
Lynn Pettis (5/8/2015)
Geez, now someone doesn't even understand that the code they are running generates and runs dynamic SQL.What is dynamic sql?
Who is...
May 8, 2015 at 4:30 pm
I do love showing people Jeff's DelimitedSplit8K function and pointing them to his article.
May 8, 2015 at 4:10 pm
Jeff Moden (5/8/2015)
SQLRNNR (5/8/2015)
Lynn Pettis (5/8/2015)
Geez, now someone doesn't even understand that the code they are running generates and runs dynamic SQL.What is dynamic sql?
Who is John Gault?
Interesting book. ...
May 8, 2015 at 4:06 pm
GilaMonster (5/8/2015)
Lynn Pettis (5/8/2015)
May 8, 2015 at 4:05 pm
jbalbo (5/8/2015)
I'm not sure what I am doing wrong I have a multi select parameter which work if I only choose one value
but I get Must declare the scalar variable...
May 8, 2015 at 4:02 pm
Jeff Moden (5/8/2015)
Lynn Pettis (5/8/2015)
May 8, 2015 at 3:49 pm
Geez, now someone doesn't even understand that the code they are running generates and runs dynamic SQL.
May 8, 2015 at 3:21 pm
rirons04 (5/8/2015)
What I have posted above is exactly what I am running. Is there something specific that I am missing?~Ryan
--select @query
execute sp_executesql @query; <<--- This runs the dynamic query that...
May 8, 2015 at 3:20 pm
It would help if we could see the actual query you are generating dynamically as I am assuming that it the query that is failing, not the query that generates...
May 8, 2015 at 3:12 pm
I must be getting cynical. Too many people are losing the ability to think for themselves and solve problems needing everything handed to them on silver platters.
May 8, 2015 at 3:09 pm
sqly2kdba (5/8/2015)
Hithank you again but this is not xml datatype its ntext data type
CREATE TABLE [dbo].[SYSTEM_ID_INFO](
[ID] [int] NOT NULL,
[SYSTEM_ID] [ntext] NULL)
select
ID,
cast(SYSTEM_ID...
May 8, 2015 at 3:06 pm
jwiseh (5/8/2015)
Unfortunately, I am a developer working with a 3rd party ERP system rigorously controlled by DBA's. In other words, turning on full text search is not gonna happen...
No faith....
May 8, 2015 at 3:04 pm
Print the SQL statement and see what is actual backup statement is that is failing. From looking at the code alone doesn't really help.
May 8, 2015 at 2:00 pm
MMartin1 (5/8/2015)
Lynn Pettis (5/8/2015)
MMartin1 (5/8/2015)
New Born DBA (5/7/2015)
Lynn Pettis (5/7/2015)
New Born DBA (5/7/2015)
Sorry, but I actually spit soda out my nose on this comment:
Well I hope you are OK. 😀
It...
May 8, 2015 at 1:26 pm
Viewing 15 posts - 5,266 through 5,280 (of 26,490 total)