Topics
Started by
Posts
Last post
can anyone explain to me what does this patindex('%,[0-9][0-9],',note) means? i saw the patindex ()…
6 replies
A friend of mine is a developer for an organization that was hacked. He asked the following, "se…
5 replies
Hi friends, can any one tell me how can we run a long script or query in smaller batches. sometime…
3 replies
I have the following data in one of the department field in a table: {\rtf1\ansi\...\deflang1033{\…
4 replies
Two tables, weekly and daily. daily contains a 'cost' for each 'productnumber' per day. weekly cont…
24 replies
Hello Everybody, i want to convert select query result to text file without use of CMDSHELL and BCP…
1 replies
I have a UDF I need to call twice. UDF name is dbo.ufn_splitToStringTable. I call the UDF to match …
7 replies
As the title says. I can do this easily with a cursor, but I'm curious how to call a procedure (sp_…
3 replies
Hi All, Any idea on this? I need to have a list of tables used by my SP. Anyone have script that r…
3 replies
All, I have to convert the below formula in TSQL standard. Please help me out. ---------------- Ann…
5 replies
I have table which has data but data has been mess up. column supposed to be unque and my task is t…
8 replies
I have a view that uses a self-join several times on the same table. It runs very well up to the fi…
3 replies
This is in SQL 2000. I need to select top (some) records from a view into a variable. I use: declar…
6 replies
Hi all, can someone tell me how to return the number of rows and the sizes and other similar inform…
10 replies
All, DBA team has populated data and logins from DEV server to QA server recently. I have to ensure…
1 replies
Viewing 15 topics - 2,476 through 2,490 (of 17,082 total)
You must be logged in to create new topics.