Topics
Started by
Posts
Last post
Hi gang ... Im a new DBA and this is my first time here. I have a bit of a delema. I want to join…
4 replies
Hi I have two tables consisting of columns one with a primary key, and another table consisting of …
23 replies
Hi, If I have a stored procedure with returns a result set and I want to set the isolation level to…
1 replies
Hi, I have a resultset derived from two non-relational tables. This resultset can best be described…
5 replies
How Can I Select Only The Values After The 1st Space And Stop Only When It Gets To The Next Space I…
1 replies
The scenario. I have a very large text file which I import to stage the data into Table dbo.tbStage…
1 replies
I am trying to write a report of no importance apart from my own use and although I can get the dat…
4 replies
How can I covert first result set into second one? This is just example. I will have million of adm…
6 replies
Hi, I need to join two tables in what I think is a 'Packing Join' as described by Joe Celko. I have…
12 replies
Am I correct in thinking that if I had a stored proc that ran the following code SET TRANSACTION IS…
8 replies
Hello All I am working with some strings that are stored in the database. Not my most favorite thin…
8 replies
Please help. I have a table with these columns: a b c d 1 2 4 5 1 …
14 replies
Consider the following: DECLARE @Datum datetime --SELECT @Datum = getdate() SELECT@Datum AS RealD…
8 replies
I'm inserting records into a table. One value is a constant: 'XYZ'. The targtecolumn is defined as …
2 replies
I have the following CTE Recursive Query: With downline (ConsultantID,ConsultantName,SponsorID,Spon…
5 replies
Viewing 15 topics - 11,236 through 11,250 (of 12,234 total)
You must be logged in to create new topics.