Topics
Started by
Posts
Last post
Mentioned below is my sql. @server and @database are created dynamically. I need to get name,type_…
4 replies
Hey Gurus and Grand Masters 😎 I have xml stored in a column with data type = text. I need to update…
1 replies
I am considering ways to achieve the following sample desired output given the sample input: decla…
3 replies
Hello, I have a situation where the cursor is not completely executing all the results coming from …
7 replies
Trying to create a consolidated sales report by store and date. The data is scattered across multi…
3 replies
Hi, I have the following Coalesce Query Coalesce (ProductClass,ProductColor,ProductID) ProductClas…
1 replies
i have a table and i am writing a procedure. my table has a unique column eg:u_column . Now, i want…
9 replies
I'm stuck, but I know this can't be too hard. I have warehouse transactions that are used to calcu…
6 replies
I have this statement that breaks due to a foreign key constraint. having a tough time figuring out…
2 replies
I have a text field that has XML in it. It is untyped and I get errors when I try to convert it fro…
2 replies
declare @a varchar(50) declare @b-2 varchar(20) set @b-2=(select gender from table where Cov='10…
5 replies
I am tring to update a column on one table from another. Using the code below it parses ok but get …
4 replies
i am looking for a way to speed up this piece of code. It is a simple while loop - which is repea…
11 replies
Hi all - got a problem which I've been struggling with for days, and have yet to come up with a sol…
3 replies
How can i find "include columns" in any index ? sys.sysindexes doesn't provide its metadata inform…
6 replies
Viewing 15 topics - 3,091 through 3,105 (of 12,234 total)
You must be logged in to create new topics.