Topics
Started by
Posts
Last post
DECLARE @XMLString table (xmldata xml) insert into @XMLString(xmldata)(select xmldata from dbo.Stg_…
6 replies
Is there a way to utilize the TRUNCATE statement on a table containing a PK IDENTITY column and als…
2 replies
Hello, I am wondering if we can get the desire result without using cursor/loop. I have a table wit…
14 replies
Hi All I have to 3 sql statements to compare the values in the dimension table. All i need is i wan…
5 replies
The example below is fictious, but hopefully explains what I want to do: I have two tables: Sales O…
9 replies
Hi, I have a query. I want to redirect the output of a query to text file. I want to execute this …
2 replies
Dears, I am using SQL SERVER 2005. I have a table to store row wise PKs' of different tables agains…
9 replies
Hi Guys, I am trying to convert transaction Date to smalldatetime but no luck. Can any one please h…
2 replies
Hi, drop table #temp1 create table #temp1 ( IDint, Codevarchar(15) ) insert into #temp1 (ID,Cod…
2 replies
What am I missing?? , cast(stuff(stuff(stuff(cast(CRM_Orders.CREATED_AT as varchar(17)), 9, 0, ' '…
6 replies
Okay I'm stumped. I need to update a value in the same table but different record based on the Use…
11 replies
I have a table in my database like the one below Table - placementconsultant placemen…
3 replies
Is there a better way to write the query to the given table ? SELECT Top 1 @ContainerUUID=Contain…
2 replies
I have a field called birthdate that inserted from a web application to the table. The data type is…
4 replies
I am trying to develop a script that will read username in table A and insert them into table B. I…
2 replies
Viewing 15 topics - 5,986 through 6,000 (of 12,234 total)
You must be logged in to create new topics.