Topics
Started by
Posts
Last post
I need to query some tables looking for All Sales that are active at the same time and have at leas…
14 replies
I have a date query as below: SET DATEFIRST 1 -- Sets Monday as First Day of Week ;with mycte as ( …
2 replies
Could you please help me find records described as per below scenario. Campus code,address,CampusID…
7 replies
how to find duplicate default constraints in a table ,example DF_abc1 is a default constraint FOR c…
3 replies
How do you create a database from a data and log file?
3 replies
Hi, Many Thanks for your help in advance, this one has my stumped. I would like to concatenate the …
10 replies
Hi, I am trying to work with data from the ProjectServer_Reporting database, which is a part of the…
6 replies
Hi people, I'm tunning a database and i've stumbled by some hierarchy queries, on the good old for…
32 replies
hi, i have 1 table which has millions of rows, i am doing select * from tablename and select count(…
20 replies
This procedure working fine in SSMS with multiple execution. Problem is application side(c#), first…
16 replies
Hi All Consider the following 2 tables create table T1 (Col1 int, Col2 int) go create table T2 (Col…
3 replies
Hi, Messing around withn SQL queries on a Sunday, so I have another question (posted my fist one th…
5 replies
I have 2 tables that are identical. I wish to copy some records from one table to the other with th…
10 replies
I have 2 tables in my database and am RIGHT JOINING the tables and it is acting like an inner join …
22 replies
Hi all - I'm trying to run an update query based on the last time the update query was run. Ex: I r…
5 replies
Viewing 15 topics - 5,161 through 5,175 (of 10,647 total)
You must be logged in to create new topics.