Topics
Started by
Posts
Last post
Does anyone have any useful SQL Queries that might be used to identify lists of potential duplicate…
7 replies
I have a dataset as such: Student TestTypeDate TestCnt 111-22-1111English2015-09-01 …
11 replies
[font="Verdana"]Hi All, I have a situation. I have one conditional UPDATE statement in stored proce…
2 replies
Hi I am trying to create a CLR function to call a webservice, the CLR function return data type is …
7 replies
Hello everyone, I've been presented with the following task and failed to come up with a working s…
8 replies
Hello comunity I have a small problem with a join clause, because i need to return all values from …
2 replies
Hello comunity I need to build an update query for all my article beginning with '0.%' for my varch…
6 replies
create table countrydetails(Countryid int,country varchar(20),stateid int, states varchar(50),sales…
5 replies
I apologise upfront if I don't explain this very well. I'm trying to create some records for a dat…
6 replies
Looking for some help to union stored procedure. The only thing that would be different is 1 variab…
2 replies
Hi is it safe to rely on the order of predicates. select 'none' fld into #t union all select 'end'…
6 replies
I am trying to create a temp table with a non-clustered index. Originally I tried to create the ind…
25 replies
Can you update data from multiple tables in the same UPDATE statement, by joining those tables in a…
7 replies
Why can you use parameters that are different in sp_executesql but the names have to match exactly …
4 replies
Hi All, I have a stored proc I want to convert it to either a Normal Query using A while loop or a…
5 replies
Viewing 15 topics - 976 through 990 (of 10,647 total)
You must be logged in to create new topics.