Viewing 15 posts - 7,036 through 7,050 (of 18,923 total)
It's not the same query... it's like asking your gps to find New-york.
But you're sitting somewhere on jupiter. Not going to work!
March 16, 2011 at 7:58 am
Steve Jones - SSC Editor (3/15/2011)
The select works for me, inside and outside of master.Not sure what's wrong for you.
of course it works, the dbname is hardcoded in the query!
March 16, 2011 at 7:33 am
The case needs to be in the select itself.
You're getting this error because you have no from clause in the case's select. So sql can't find the columns and...
March 16, 2011 at 7:19 am
I've had the same "issue" when showing the reports on the web. However iirc when exporting that issue was gone.
My guess was that MS changed the way the reports...
March 16, 2011 at 7:17 am
lindsaywang (3/15/2011)
Is there anybody can help me take a look?
I want to create one temp tble by using the query like select * into #tmptbl from EXEC SP......
March 16, 2011 at 7:15 am
Just to add to what Lynn is saying. How do you identify the rows that need to be deleted?
Once you have that figured out it's easy to code the...
March 16, 2011 at 7:01 am
Can't find anything usefull on google. I guess I'm searching for the wrong terms!
The only idea I have is to replace * with something silly like [star] and then...
March 15, 2011 at 10:55 am
quillis131 (3/15/2011)
Mid(day(date) + 100,2,2)help me in understanding this plz...i am new to this kind of stuff...help me plz
Assuming vb6 transposes to ssis :
day(date) would be 15 today.
so that makes...
March 15, 2011 at 10:41 am
Have you tried doubling it or using brakets around it?
March 15, 2011 at 10:39 am
I'm thinking the other way around completely.
Get a "change log". Generate dynamic sql from there and exec.
No need to loop in all tables if only 1 table was changed.
March 15, 2011 at 10:19 am
Option Z
Rename old table, drop all constraints (name conflicts)
Then create new table with all constraints and indexes.
You still have a backup of the table and you have an empty table...
March 15, 2011 at 9:41 am
Once the domain is setup on the new location, plug a pc and try to connect.
Debug if it fails.
repeat step 1 untill it works.
The server is working now. So...
March 15, 2011 at 9:38 am
tuseau (3/15/2011)
Customers are not happy with truncate being used...
March 15, 2011 at 9:35 am
Run the delete in smaller batches (top 10 000)
Run as long as @@rowcount > 0.
That was my whole point about bcp, you can reimport if something goes wrong. Then...
March 15, 2011 at 9:33 am
Steve Jones - SSC Editor (3/15/2011)
The early bird rates have typically never included a discount because they are...
March 15, 2011 at 8:26 am
Viewing 15 posts - 7,036 through 7,050 (of 18,923 total)