Topics
Started by
Posts
Last post
I am trying to insert data into a database on a remote server using linked server: SELECT * INTO [L…
7 replies
I'm using management studio to excute a stored procedure. The stored procedure have both input and …
7 replies
I need to create dynamically XML including namespace declaration at the top level As a start I have…
6 replies
I struggled with this for a while and I know I am not the only one. So, since I have received help …
4 replies
I've just noticed something here - when I execute print@@datefirst on a particular database on SQL …
3 replies
Hi, I have relisted this from a post I placed about 2 weeks ago as I didnt explain myself very wel…
10 replies
I am writing a process to send XML files to a external party on a daily basis that contain all the …
9 replies
Hi, I need ur help.. I have a table which contains on and off status of a meter. Feederstatus = 0 m…
9 replies
Hi i have two tables 1. Table A ID---Name 1----Abs 2----Cex 3---Dex Here ID in table A is an Identi…
1 replies
Hi Guys Please help I have the following code which when executed generates a script to Rebuild In…
7 replies
Hello, I need a script to change the type of a column from char(n) to nvarchar(n) where n is the le…
3 replies
Hello All, I followed the following steps: use test_db go Create Table SystemPasswords (ID INT IDEN…
14 replies
SET @Date = '2011-01-01' SET @Date1 = '2011-01-30' WHILE (@Date<=CONVERT(DATE,@Date1)) BEGIN …
4 replies
Hi I am trying to find the first day of a week/month Example SELECT DATEADD(wk, DATEDIFF(wk, 6, '20…
20 replies
Urgent help please Ways to Improve this function: CREATE FUNCTION [dbo].[LBS_Quotes_GetEarliestCur…
6 replies
Viewing 15 topics - 7,411 through 7,425 (of 10,647 total)
You must be logged in to create new topics.