Topics
Started by
Posts
Last post
Guys, I need to join two tables together - Master and Detail Master Table:ID =7000776601*1*6994Code…
10 replies
Scenario : we have a stored procedure named : usp_dummycreate procedure usp_dummyasbegin trybegin t…
4 replies
I'm having a weird string truncation issue that we've fixed, but it driving me nuts and was hoping …
5 replies
I am working for a company that still uses Sql 2008 R2 and so i cant use Lead/Lag Functions. I know…
5 replies
SELECT codart,quantite,datfac,count(quantite) over (partition by codart order by codart ) as qte FR…
3 replies
Hi all, I've created thousands upon thousands of stored procs, and I can probably count on one hand…
8 replies
Hi,Sorry If it is a lame question. I am trying to understand the cursors. I dont understand th…
1 replies
Here's a problem I ran up against today on a SQL2008 instance. I have an existing Stored Procedure …
3 replies
Hi I need to update 600,000 rows in the table column with files from the file system. I see there a…
7 replies
Dear Friends, I m validate one alphanumeric character string for learning purpose My character set …
7 replies
Guys, I am trying to redesign a terrible process for generating financial statements with a funky S…
3 replies
I came across something interesting while troubleshooting a developer's code recently. We use…
12 replies
Hi,I need some help with a query. In the picture you see three tables. I want all rows in tblSales …
3 replies
This query: SELECT [charindex] = charindex('',''), [patindex] = patindex('','');Returns:charind…
4 replies
We are using Change Tracking with CHANGE_RETENTION = 5 DAYS . . ALTER DATABASE DTJX0_CSISET CH…
4 replies
Viewing 15 topics - 271 through 285 (of 10,647 total)
You must be logged in to create new topics.