Topics
Started by
Posts
Last post
I'm working on a script to produce XML. There are two parts to the XML: an envelope (called "messa…
5 replies
Good day forumites, I have a unique request here. I have the following table CREATE Table #Table1 …
3 replies
I have the some data in one of a temporary table inside a stored procedure. I want to take the firs…
19 replies
Hi All, I am trying to add month to a date. Here is my code declare @CollectionDate date='10-28-20…
3 replies
having below data. SHCOMP (Customer ID), CBLNAM ( Customer name), SHDESC (service description), SHA…
5 replies
Hi, I have a procedure (a) where i call another procedure (b) passing @message as a parameter to pr…
3 replies
Hello, I have created a variable in a SQL Task and assigned it to a string variable. When I debug t…
2 replies
Hi, I am running sqlserver 2012. My output data is like COL1 aaa bbb ccc Now, i want to convert the…
2 replies
Hi, I'm writing a view to check record counts in a table that has numerous datasets and therefore v…
3 replies
Hi, I am working with a query. I am looking for an alternative to not exists. Is the exception work…
7 replies
I have a table where one of the fields contains XML as in the following. Is there an SQL update sta…
6 replies
Hi , I am working with a query. I need to change the query select distinct top(10) RV.Id, RV.Purch…
16 replies
Hi, I am writing a query to update table variable. It is throwing me some error. I have a table var…
11 replies
I am needing to get average and total downtime hours from a table. I have two source tables, DOWN (…
7 replies
I know some SQL scripting but this one I've been trying to figure out for awhile. I'm using a SQL s…
5 replies
Viewing 15 topics - 4,051 through 4,065 (of 4,984 total)
You must be logged in to create new topics.