Viewing 15 posts - 11,011 through 11,025 (of 13,872 total)
Jeff - that's a great idea.
November 30, 2011 at 6:25 am
Mr. Holio (11/30/2011)
Can someone pls help me with the following? I'm trying to to do a few tests and to use PIVOT (for the first time) but couldn't get...
November 30, 2011 at 4:20 am
engrshafiq4 (11/29/2011)
YOu right clicked on database ....i just want to export one table and then import that table in another db....i can view like ur attached
Yes I did. And which...
November 29, 2011 at 4:55 am
Are you looking in the right place? Check attached screen shot to confirm.
November 29, 2011 at 4:46 am
Gianluca Sartori (11/29/2011)
alaguganesha1983 (11/29/2011)
Try replication between the two server.Seems to me a bit of overkill for just a couple of tables...
Agreed with this and with your previous post: if there...
November 29, 2011 at 2:20 am
Richard Moore-400646 (11/28/2011)
November 28, 2011 at 1:48 pm
Pulivarthi Sasidhar (11/28/2011)
My SQL query returns data with HTML Code as single row
I used Execute SQL task & Objects variable to get the SQL resultset.(When i used String variable it...
November 28, 2011 at 4:40 am
I remember now why I didn't respond to this post originally. This sentence:
when i rerun the package it should overwrite the existing package in the share folder.
worried me - the...
November 25, 2011 at 5:07 am
karthikeyan-444867 (11/23/2011)
Note all the securties will have the returns from...
November 23, 2011 at 7:02 am
viiki.seth (11/23/2011)
What is the question here?
I still don't know the answer to this.
To Karthik: please post your exact question clearly, without expecting us to guess it based on your scenario.
November 23, 2011 at 6:44 am
OK - but I asked about the column names and I'm not sure that you've tried what I suggested.
In your SQL for the extraction from the view, try aliasing the...
November 22, 2011 at 2:59 pm
david.ostrander (11/22/2011)
I wish it was that. I tried to remove the spaces with no such luck.This is an image from the table that the view reads from (attached)
That's not...
November 22, 2011 at 2:23 pm
Could it be a problem with spaces in the column names?
November 22, 2011 at 2:13 pm
I had to do something very similar recently. Check this thread for a fast T-SQL solution (and many other interesting suggestions!)
November 22, 2011 at 10:30 am
Hi Jason
This stuff is much easier to read if you use code="sql" tags (+ thanks to SQL Prompt for reformatting):
declare @ServerName as varchar(60)
set @servername = 'yourservernamehere'
create table TEMPDB.dbo.tFreeSpace
(
...
November 21, 2011 at 5:09 am
Viewing 15 posts - 11,011 through 11,025 (of 13,872 total)