Topics
Started by
Posts
Last post
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
Hi, I need a small clarification. Please see the below code. DECLARE @var1 NVARCHAR(100) DECLARE @v…
4 replies
Hi All I am writing a SP, i got stuck with a problem, i am using a where clause to sea…
4 replies
Hello, I have a question regarding distributed transactions. I have 2 SQL servers, each linked to …
1 replies
Hi guys, I want to create a script to loop in all tables to reseed the identities in a specific dat…
4 replies
Viewing 15 topics - 5,986 through 6,000 (of 12,230 total)
You must be logged in to create new topics.