Topics
Started by
Posts
Last post
Hi all, Is there a way to change the current user in T-SQL? I need to be able to run certain parts …
3 replies
Query for tables index properties Instead of using Enterprise Manager and going into design of a ta…
5 replies
Hi, I have a "tblShop" table in my database that holds the shop name and branch locations like this…
6 replies
Hello, I have data in a normalized form: KEY1 | STRING1 KEY1 | STRING2 KEY1 | STRING3 I would like …
3 replies
Hello all I have upto 12 excel files being generated every day. Each file has 2 worksheets and the …
5 replies
I need some suggestions for using or more identifying what record in a table was inserted, updated,…
5 replies
I am using the the SP below to round in 1 ,3 and 10 minute increments of an hour. It's rudime…
1 replies
Hi all, just noticed something strange with sql server- if you divide one number by another …
20 replies
I have 2 SP's,the result of the 1st SP shud be passed as parameter to the second SP,can any help me…
8 replies
I am trying to return -1 if no records match but because of my calculation the rowcount is thrown o…
3 replies
What would the T-SQL be for creating a new table that is identical to another table?
4 replies
Hi, I want to pick up the value in a table and add one to it as the next sequence number. This se…
6 replies
I have a stored procedure where a SQL string is built depending on a bunch of input parameters. Whe…
1 replies
I have string which goes beyond 8000 character What can i do for it I have tried with Seperating Qu…
1 replies
I have a table of names and addresses, there are some people with the same address i also have a fi…
1 replies
Viewing 15 topics - 8,956 through 8,970 (of 17,082 total)
You must be logged in to create new topics.