Topics
Started by
Posts
Last post
Can someone please provide the code or even the logic to this proc that i will use in my SSIS. An o…
7 replies
I have the following code: /* CustPmt - Copy the Payment Number into the Comment Fiefd */declare …
4 replies
I have attached the sample xml code for reference. What i want to do is. getting the values for eac…
3 replies
Why would the following code produce this error: Msg 156, Level 15, State 1, Line 2 Incorrect synta…
6 replies
Hi forum, I'm writing a procedure that will receive a few parameters which will update or insert re…
9 replies
hi all, today one of my friend told me CTE is called as inline view. then I asked what is the diffe…
26 replies
I need to troubleshoot a problem in ETL process and store one of SELECT's in sp in a temp table bu…
2 replies
Is it possible to alter multiple columns in one call .vs doing this: ALTER TABLE dbo.coChargeCodes…
2 replies
Is it possible to insert a summary into the following sql statment? I'd ideally like to sum all the…
1 replies
I have multiple databases on the server that have slightly different structures. I need to create a…
4 replies
We need to write a stored procedure which works like a search engine. The data has to be fetched fr…
2 replies
I have a field which contains dates in CHAR(8) format e.g. 11/08/08 = 11th August 2008. However, if…
4 replies
If I want to convert a string to a datetime, if the conversion fails, can I set it to a default val…
3 replies
I want to return multiple rows if there are multiple TODO entries in the SP text. I have tried a f…
3 replies
Hi, I have three columns a, b ,c (all strings) i want to set default value of c as a + '-' + b is…
3 replies
Viewing 15 topics - 9,151 through 9,165 (of 12,230 total)
You must be logged in to create new topics.