Topics
Started by
Posts
Last post
Good day Experts, I am new to Sql and i have a stored proc with a colomn name @BackupDrive2 nvarcha…
2 replies
i have 2 tables one is emp and another is emp1 Step 1 : IN Stored procedure pass input empid,from_d…
11 replies
Hi, Simple little requirement. Need to display first date of each of the 12 months prior to current…
37 replies
Hi everybody. I noticed a strange behaviour using a 'select into' statement with an identity column…
3 replies
Using While Loop i want to insert the values into single record like this Empid empname D1 D2 D3..…
42 replies
good afternoon , I'm hum code that brings me the values of the fields Table , however When I " * …
7 replies
Hi we have an ETL from one DB to another on the same server but we don't want to use SSIS and we wa…
1 replies
Hi, I dont speak so much english...sorry I have a views and tables in a server Oracle, in my server…
2 replies
Hello SSC Members, I am not sure if many SSC members have started to use Column Store indexes but I…
1 replies
hi, Trying to find the below condition If he is shift 1 shifttype 1 then the record comes from empl…
14 replies
IF Object_id('tempdb..#blocked') IS NOT NULL DROP TABLE #blocked select '201' spid,'200' Blocki…
2 replies
Hi All, have the follwoing stored prcoedure Create procedure Test ( @TestDate1 smallDatetim…
5 replies
Hi All, Please can I get some assistance with this trigger. I created the trigger and it's workin…
5 replies
Hi All, I am passing three date variables in the stored procedure. Depending on whichever variable…
2 replies
Hi All, I am passing a parameter as @col1. I need to set col3 to 100 if @col1 =1 else col3 will be…
4 replies
Viewing 15 topics - 2,086 through 2,100 (of 3,067 total)
You must be logged in to create new topics.