Topics
Started by
Posts
Last post
Creating a lookup table SELECT TOP 1000 [uniquerowid] INTO #TempDeleteLookup FROM PRTran WITH (NOLO…
8 replies
Hello, I am using FOR XML PATH to retrieve data from a set of tables as xml output. However, I run …
2 replies
I am using the sample AdventureWorks database with the following query: SELECT [SalesOrderID] …
12 replies
I have a table that contains some network throughput data that is collected every 9 minutes. I nee…
1 replies
Is it possibly to simply pivot to change the way a result set looks? In by that, I have two columns…
6 replies
This might be a very silly question. How can I get name of the script which is getting executed. I …
3 replies
Dear all, I am trying to write a stored procedure that splits a file content (sent as one VARCHAR(M…
14 replies
Hi. Wonder if someone can help with this as it's now driving me to distraction? I have a Time-sheet…
5 replies
I don't seem to get an option to have a text delimiter when I choose 'results to file'. I can set t…
3 replies
Hello I have a little problem, I have created a report which generates information which in include…
2 replies
Hello, I have maintenance script that I need to run on several databases. I want to create a tempo…
15 replies
Hi all, I have created a procedure to update table records by passing Xml values but im getti…
2 replies
Hello, I want to write query for: I have a purchase orders table and structure is like: POID | POQu…
16 replies
hi all , im joing two tables using union and displaying result , but here i want to dis…
3 replies
Hi In a table, i am having identity values of 200. I am deleting all the records. I need to insert …
2 replies
Viewing 15 topics - 9,526 through 9,540 (of 12,230 total)
You must be logged in to create new topics.