Topics
Started by
Posts
Last post
I am trying to group a dataset into 2 sets of data. One which has a certain field asccoiated with a…
1 replies
Below is a little sproc that I have with-in my get_ShippingCost sproc. What I need to do is add a c…
5 replies
I have a customer table with a zip code in it. I have a rep zip table with zip code ranges. Cust…
2 replies
Hi everybody, I keep getting this error : Msg 3609, Level 16, State 1, Line 1 The transaction ende…
1 replies
Hi there, Does anyone have any useful code that I can use to show distributions of data ? Here's so…
6 replies
What is the quickest and most effective way of learning T-SQL?
7 replies
I wonder if anyone can help with an issue that we are having with when trying to run a job that res…
2 replies
I have a table with two columns Id(PK,Identity) and size of int type. size have some duplicating en…
6 replies
Hey Guys.. Is there any way to reset the identity key to 1 without using DBCC CHECKIDENT? I have a …
9 replies
Msg 242, Level 16, State 3, Line 23 The conversion of a varchar data type to a datetime data type r…
8 replies
what is the syntax to insert a value from table 1 into a xml data type field in table2? Another wo…
1 replies
Hi I am new to these triggers, please help me out. I have to create a trigger which creates a temp…
9 replies
Just curious, can you have a clustered index and non clustered index on the same table? :hehe:
5 replies
Trying this set datefirst 7 go select DATEPART(week,convert(date,'31/12/2010',103)) as weekno, DATE…
1 replies
Hello SQL gods, 😉 I've created a scalar-valued function that returns a figure. I pass in a variabl…
8 replies
Viewing 15 topics - 7,951 through 7,965 (of 10,647 total)
You must be logged in to create new topics.