Topics
Started by
Posts
Last post
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
Hi, I need some help with a SQL query. I've been trying to find a way to get the desired informatio…
2 replies
I have the below tsql running on a new sql box with 32 gig of ram select a.FacID, a.PatID, PatName,…
7 replies
Current Query: Select person_id, (Select 'Y' From notes where note_date > '06/23/2008' AND note_…
1 replies
I need to remove all rows from a table based on the date value being at lease sixty days old from t…
3 replies
Viewing 15 topics - 9,226 through 9,240 (of 12,230 total)
You must be logged in to create new topics.