Topics
Started by
Posts
Last post
I have the following code: DECLARE @StartRangeAmount Decimal(19,2) DECLARE @EndRangeAmount Decimal(…
5 replies
In SSMS As i try to disable the trigger with following statement DISABLE TRIGGER triggerName ON dat…
10 replies
Hi, I am trying to setup some data in this case open sales orders showing open all orders by period…
3 replies
Hi there, Given the following…. declare @qrystr varchar(4000) set @qrystr = 'select * from table1'…
2 replies
Please critique this Stored procedure. I am not new at writing them but this one *should* be easy a…
2 replies
Hi All, I need to create a complex join, (in my eyes) 🙂 I want to create a query in my HP SIM db, s…
24 replies
Dear all, I have a value of 2007/01/01 which I would like to convert to INT ie 20070101 I have the…
4 replies
I have include a few scripts to show what I am trying to do. The problem that I am having is the F…
5 replies
Hi GURUZ, I have successfully import XML data into SQL server 2005, now problem is I want to see th…
2 replies
Hi, Can you help pls. I get a list periodically in an Excel format of people who have changed addre…
3 replies
I`m using this select to lock some rows:SELECT * FROM E2 WITH (UPDLOCK) WHERE A1=1 1.) I want to l…
1 replies
Wht is the best way(in t-sql) to import 2 columns from Excel sheet into a table, this will be a job…
8 replies
I have xml stored in xml data type's in Sql Server 2005 in the following format... ## see attachmen…
5 replies
We have several SQL scripts we would like to run against multiple databases on the same server. So …
3 replies
I am getting the following error with the SP shown below sp_EdicionImpresaDetalles 912,0,0,0,'' Msg…
4 replies
Viewing 15 topics - 9,226 through 9,240 (of 12,234 total)
You must be logged in to create new topics.