Topics
Started by
Posts
Last post
we have a job that runs every 5 minutes to synchronize (merge) data from a remote database to a loc…
7 replies
Hi All, I've a table which gives the output when queried normally. I want to transform rows to colu…
21 replies
Hello all, I'm new to SQL and also new to this forum. I hope everyone is well, I just had a couple …
7 replies
After testing I've raised our production cost threshold for parallelism from the default of 5 to 25…
11 replies
Can someone please tell me why it returns error for this block? I would expect the BEGIN would not …
4 replies
Hello, We upgraded our database server from windows server 2008 r2 sp1 to windows server 2012 r2. I…
4 replies
I have a table that contains product data and a table that contains what products a user has purcha…
6 replies
Hi I have 2 tables Product , Attribute. In Attribute Table i have 3 fields . I am passing SpecsId…
2 replies
Hi Friends , i would like to replace null as zero , please some one help me . for ur reference i ha…
9 replies
Hi gurus, I need to join ::fn_trace_gettable TO sys.procedures. So I get extra below columns. DDL …
5 replies
CREATE TABLE Test (ID char(1)); with cte as ( select 'x' as ID union all select 'x' as ID union all…
2 replies
Our environment is a little weird. Instead of just using a maintenance job or backing up dbs to one…
5 replies
I've created the below query to retrieve some information on agent jobs scheduled which works fine …
6 replies
I have 2 tables: Table_A (InsuranceNo, JobNo,Processed) values('Anton1',NULL),('Jason1', NULL),('Ci…
11 replies
Can someone please tell me why the following code returns 1 instead of 0? [font="Courier New"]selec…
2 replies
Viewing 15 topics - 1,801 through 1,815 (of 4,984 total)
You must be logged in to create new topics.