Topics
Started by
Posts
Last post
I've been using Script Task to check for the existence of File(.xls) in a folder(directory). I've w…
4 replies
Hello: I have this query:SELECT DISTINCT F.DocumentID, F.[Filename], F.LatestRevisionNo, V.ValueTex…
10 replies
Hi all Could anyone shed any light on the problem I have using BULK INSERT please? It's not somethi…
6 replies
Hello: I have this query:SELECT F.DocumentID, F.[Filename], V.VariableID, V.RevisionNo, V.ValueText…
14 replies
I have a database where I have implemented view level partitioning. I have created separate f…
1 replies
I have the following setup2 linked servers - on one server (sql2014) is rather complicated vie…
34 replies
Here is procedure I am trying to create: ALTER PROCEDURE p_UpdateBorrowerNote -- Add the paramet…
8 replies
Hi All,This is generic question which I may follow up and post some code on at a later date but I j…
5 replies
Did anyone come across this scenario where a developer/analyst comes in and pass multiple values fo…
12 replies
Hi there, I've tried all kind of methods but I just can't get sql to trim the last "," from my stri…
6 replies
Hi guys, I am looking for a query that can switch my rows and columns in the table below :The final…
3 replies
Hi, Bit of a broad one this so I'll start at the beginning. We have a third party database which st…
2 replies
Suppose we are selling bottles of water that can be bought in sizes of 1 to 10 litres (1, 2, 3, etc…
14 replies
Hi I have a Stored Procedure that uses #temp tables. it creates them and drops them within the SP. …
1 replies
Hi, I am struggling with a select statement because the data structure needs to change a bit. …
1 replies
Viewing 15 topics - 1,351 through 1,365 (of 3,067 total)
You must be logged in to create new topics.