Viewing 15 posts - 11,296 through 11,310 (of 15,376 total)
dtopicdragovic (7/19/2012)
It is hard to explain and the process itself is very complicated.
More I work on it gets more confusing. :angry:
We want to show to our contacts what we have...
July 19, 2012 at 1:16 pm
dtopicdragovic (7/19/2012)
July 19, 2012 at 12:37 pm
sqlfriends (7/19/2012)
I cannot connect to this server somehow from other SSMS client.
And on the server itself no SSMS installed, there...
July 19, 2012 at 10:55 am
That would far too complex to automate. What if you are using new datatypes? What about table parameters?
We can help you rework it but you need to post the script...
July 19, 2012 at 10:53 am
A quick google search would be way faster for this type of thing. I typed "view collation sql server"...here is hit #1.
http://blog.sqlauthority.com/2007/08/30/sql-server-2005-find-database-collation-using-t-sql-and-ssms/%5B/url%5D
July 19, 2012 at 10:50 am
pdanes (7/19/2012)
Sean Lange (7/19/2012)
Check out Gail's blog post on catch all queries. This explains a couple of ways to go about this.http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D
Thanks, that also helped clear up some confusion about...
July 19, 2012 at 10:28 am
Celestial (7/19/2012)
DescriptionNode(HierarchyID)StringPath
Manager0x /
Dev Manager0x58 ...
July 19, 2012 at 10:25 am
There are several ways you could handle this. One might be to change the ISNULL to check to a case statement.
Something like:
case when na.UserID is null then ui.FName else na.FName...
July 19, 2012 at 9:59 am
Check out Gail's blog post on catch all queries. This explains a couple of ways to go about this.
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D
July 19, 2012 at 9:53 am
dtopicdragovic (7/19/2012)
Our web...
July 19, 2012 at 8:22 am
Right click on the database --> Tasks --> Generate scripts.
This will bring up a script wizard. You can select everything in your database including all indexes, keys, constraints etc... You...
July 19, 2012 at 8:21 am
This should work but you have a couple issues. You said you want to load in batches of 10. You select top 10 but limit it to 5 rows with...
July 19, 2012 at 8:16 am
Well it is very unclear what you are trying to do here. Do you have these tables designed already? Can you post the ddl, sample data and desired results? I...
July 19, 2012 at 7:08 am
Mohammed Yousuf (7/18/2012)
lets say the column is ItemNumber
The ItemNumber can have both numeric and...
July 18, 2012 at 1:35 pm
tacy.highland (7/18/2012)
I'm trying to build it as a matrix, with the route number as a row, and each 15 min increment (for the whole day)...
July 18, 2012 at 1:12 pm
Viewing 15 posts - 11,296 through 11,310 (of 15,376 total)