Topics
Started by
Posts
Last post
Hi guys. i have two tables , Table1 has only Col1 and Table2 has Col1,Col2... what i did, Table1(Co…
17 replies
By: GSquared
Hello, Does any one have list of DO's and dont's for writing effective SQL? I am looking for some b…
3 replies
Hi All, I have a table that contains purchase order lines where some lines relate to the same job n…
9 replies
Anyone know if there is an alternative to STATS_DATE? I don't to use dynamic SQL for what I'm worki…
1 replies
Hello All, Again, I am a Newbie currently polishing up on my freshly completed training. Below is …
1 replies
Hi All, This should be simple but I seem to be playing with my mental blocks today. In the followin…
7 replies
Hi, I want to change multiple column datatypes in a single query. If any one knows the answer, plea…
4 replies
Given the same textual data, is an inner join to a VARCHAR(MAX) any less efficient than the same jo…
1 replies
Morning all, I'm importing server event logs into a database, then using sp_send_dbmail to send out…
2 replies
By: gpowers
We have a name and name_address table in our iMIS database. The name_address table stores three se…
9 replies
This seems simple enough, I'm trying to get a count of employees by different indicators. First tot…
1 replies
All: The DB I'm working with stores a date in a varchar field (don't blame me - I didn't design it)…
16 replies
hi , INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\test.…
4 replies
Maximum Number of rows allowed in sql server 2005 tables ? Maximum Number of columns allowed in sql…
5 replies
hi , use msdb select * from dbo.sysjobhistory i know this query to see detail of all jobs but i w…
4 replies
Viewing 15 topics - 10,561 through 10,575 (of 12,234 total)
You must be logged in to create new topics.