Topics
Started by
Posts
Last post
I switched over a stored procedure FROM "OPENXML" to a more Sql Server 2005 syntax. My performance …
3 replies
Hi, can anyone help me to find out which process are idle for more that 20 min with a tsql . Regar…
1 replies
Hi all, I get this error while i run my SQL job . spExtractTable Failed @ Line 1, The OLE DB provid…
1 replies
Can I use IN clause in CASE function. I have a table. CREATE TABLE TABLE1 (ID INT IDENTITY(1,1),Rev…
6 replies
Hi Can anyone suggest me how to find if there are any trailing spaces in a field? I would appreciat…
4 replies
Could someone explain how to convert this size to gigabytes? I look at it, and I can't figure out …
3 replies
I have the following 2 tables: CREATE TABLE TXN ( INT ,txnDate DATETIME ) CREATE TABLE PERIOD …
4 replies
I'm still a newbie when it comes to some things in SQL Server 2005. I've recently come across a sc…
3 replies
I have a sproc that filters on the SiteNumber field of a table but I also want to give the user the…
14 replies
What I'm trying to achieve: Let's assume I have a Table with columns like this: firstname,lastname,…
8 replies
Hello. I have a select that returns some SubCategories. SELECT SubCategoryID from SubCategories SCA…
4 replies
Hello everyone, is there any SQL stmt to access log? Can i go into log file just as we go in MDF fi…
1 replies
Issue is I have multiple columns being returned where I just need the latest. I have tried to use M…
2 replies
I have a stored procedure that has several parameters that are passed in that are used for differen…
10 replies
I had one of our programmers come to me this morning and she is trying to update some information i…
6 replies
Viewing 15 topics - 10,171 through 10,185 (of 12,234 total)
You must be logged in to create new topics.